SELECT p.PrescriptionID, c.LastName, c.Phone, p.IssueDate, m.BrandName, pd.Quantity
FROM ((Prescription p INNER JOIN Customer c ON p.CustomerID = c.CustomerID)
INNER JOIN Prescription_Detail pd ON p.PrescriptionID = pd.PrescriptionID)
INNER JOIN Medicine m ON pd.MedicineID = m.MedicineID
WHERE p.Status = "Pending";